create  table jms_dm.dm_center_stop_time_sum_dt  (
date_time date COMMENT '日期' ,
agent_name varchar(100) COMMENT 't代理区' ,
center_name varchar(100) COMMENT 't中心名称' ,
center_name_code varchar(100) COMMENT 't中心编码' ,
all_total bigint COMMENT '操作总票数' ,
send_count bigint COMMENT '发件票数' ,
send_avg_time decimal(10,4) COMMENT '发件平均时长' ,
send_tx bigint COMMENT '发件36' ,
sned_fe bigint COMMENT '发件48' ,
send_car_count bigint COMMENT '发车票数' ,
send_car_avg_time decimal(10,4) COMMENT '发车平均时长' ,
send_car_tx bigint COMMENT '发车36' ,
send_car_fe bigint COMMENT '发车48' ,
invalid bigint COMMENT 't有到无发票数或有发无到票数' ,
tx_rate decimal(10,4) COMMENT 't超36小时占比' ,
fe_rate decimal(10,4) COMMENT '超36-48小时占比' ,
up_fe_rate decimal(10,4) COMMENT 't超48小时占比'
     )
 ENGINE=OLAP
DUPLICATE KEY(date_time)
COMMENT "中心停留时长取数,汇总"
PARTITION BY RANGE (date_time) (
    START ("2022-07-01") END ("2022-09-30") EVERY (INTERVAL 1 day)
)
DISTRIBUTED BY HASH(date_time) BUCKETS 4
PROPERTIES (
"replication_num" = "3",
"dynamic_partition.enable" = "true",
"dynamic_partition.time_unit" = "DAY",
"dynamic_partition.time_zone" = "Asia/Shanghai",
"dynamic_partition.start" = "-365",
"dynamic_partition.end" = "3",
"dynamic_partition.prefix" = "p",
"dynamic_partition.buckets" = "4",
"in_memory" = "false",
"storage_format" = "V2"
);